SELECT *, CASE WHEN `name` LIKE "mount pleasant%" AND `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "mount pleasant" AND `logo_file_name` IS NOT NULL THEN 10 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "mount pleasant" AND `logo_file_name` IS NOT NULL THEN 2 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "mount pleasant" AND `logo_file_name` IS NULL THEN 1 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` IS NULL AND `logo_file_name` IS NULL THEN 0 END as `rank` FROM `wp_slides` WHERE st = "SC" AND (locality IN ("mount pleasant") OR locality IS NULL) AND (cat IS NULL) AND name NOT IN ("home-top", "home-bot") AND (slide_file_name IS NOT NULL AND slide_file_name != "") AND (slide_location IS NULL OR slide_location = "") AND name NOT IN ("agent") AND active = 1 ORDER BY `rank` DESC LIMIT 12
[0] matching rows / [0.00 msec]
Blog ID 30
Blah
SELECT *, "0" as `rank` FROM `wp_slides` WHERE st = "SC" AND (cat IS NULL) AND (slide_file_name IS NOT NULL AND slide_file_name != "") AND (slide_location IS NULL OR slide_location = "") AND active = 1 ORDER BY `rank` DESC LIMIT 12
[0] matching rows / [0.00 msec]
Blog ID 30
Blah
Get email when new and updated listings match this saved search.
Get email when newly sold listings match this saved search.
Save Search
Delete Shape
Click on these drawing tools to draw shapes to contain listings. You can save these shapes as a Saved Search.
$7,499,000957 Pitt StMount Pleasant SC 29464View Listing
$6,500,000339 Bayview DrMount Pleasant SC 29464View Listing
$5,395,0002318 N Palmetto Fort DrMount Pleasant SC 29466View Listing
$4,700,0001583 Porchers Bluff RdMount Pleasant SC 29466View Listing
$4,295,0003893 Ashton Shore LnMount Pleasant SC 29466View Listing
$4,125,000174 N Shelmore BlvdMount Pleasant SC 29464View Listing
$3,995,0001490 Old Rosebud TrlMount Pleasant SC 29429View Listing
$3,795,0003925 Ashton Shore LnMount Pleasant SC 29466View Listing
$3,500,0003922 Ashton Shore LnMount Pleasant SC 29466View Listing
$3,500,000636 McCants DrMount Pleasant SC 29464View Listing
$3,490,0001620 Home Farm RdMount Pleasant SC 29464View Listing
$3,400,000414 Creek Bend WharfMount Pleasant SC 29464View Listing
$3,300,0001110 Chuck Dawley BlvdMount Pleasant SC 29464View Listing
$3,295,0003934 Ashton Shore LnMount Pleasant SC 29466View Listing
$3,295,000654 Atlantic StMount Pleasant SC 29464View Listing
$2,995,0003891 Sawyers Island DrMount Pleasant SC 29466View Listing
$2,950,0001495 Pocahontas StMount Pleasant SC 29464View Listing
$2,895,000728 Pitt StMount Pleasant SC 29464View Listing
$2,875,0003900 Ashton Shore LnMount Pleasant SC 29466View Listing
$2,850,0002733 Fountainhead WayMount Pleasant SC 29466View Listing
$2,800,0001678 Omni BlvdMount Pleasant SC 29466View Listing
$2,799,0004180 Victory Pointe DrMount Pleasant SC 29466View Listing
$2,700,000151 5th AveMount Pleasant SC 29464View Listing
$2,700,0001636 Home Farm RdMount Pleasant SC 29464View Listing
The data relating to real estate for sale on this site comes from ListHub. All properties are subject to prior sale, changes, or withdrawal. This site was last updated May-09-2024 4:21:25 am.
SELECT *, "0" as `rank` FROM `wp_slides` WHERE st = "SC" AND (cat = "lenders" OR cat IS NULL) AND (slide_file_name IS NOT NULL AND slide_file_name != "") AND (slide_location IS NULL OR slide_location = "") AND active = 1 ORDER BY `rank` DESC LIMIT 12
[0] matching rows / [0.00 msec]
Blog ID 30
Blah